/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_mdse_rela_flow_his.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_MDSE_RELA_FLOW_HIS
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_mdse_rela_flow_his.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "app97_global.h" 
#include "table_ppm.h"

CTable_PPM_MDSE_RELA_FLOW_HIS::CTable_PPM_MDSE_RELA_FLOW_HIS( )
 :NPCRecordSet( )
{
  setTableName( "PPM_MDSE_RELA_FLOW_HIS" );
  prepareTable();
  prepareQuery();
 
  HIS_ID.setField( "HIS_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( HIS_ID );
  makeKeyItem( HIS_ID ); 
  ID.setField( "ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( ID );
  FLOW_ID.setField( "FLOW_ID", DATA_CHAR, 20, 0 );
  makeTableItem( FLOW_ID );
  STAFF.setField( "STAFF", DATA_CHAR, 6, 0 );
  makeTableItem( STAFF );
  FLOW_NAME.setField( "FLOW_NAME", DATA_CHAR, 64, 0 );
  makeTableItem( FLOW_NAME );
  DESCRI.setField( "DESCRI", DATA_CHAR, 128, 0 );
  makeTableItem( DESCRI );
  STATE.setField( "STATE", DATA_CHAR, 6, 0 );
  makeTableItem( STATE );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
  REMARK.setField( "REMARK", DATA_CHAR, 512, 0 );
  makeTableItem( REMARK );
  APP_ID.setField( "APP_ID", DATA_CHAR, 20, 0 );
  makeTableItem( APP_ID );
  APP_STATE.setField( "APP_STATE", DATA_CHAR, 20, 0 );
  makeTableItem( APP_STATE );
  OFFER_NBR.setField( "OFFER_NBR", DATA_CHAR, 128, 0 );
  makeTableItem( OFFER_NBR );
}


CTable_PPM_MDSE_RELA_FLOW_HIS::CTable_PPM_MDSE_RELA_FLOW_HIS( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_MDSE_RELA_FLOW_HIS" );
  prepareTable();
  prepareQuery();
 
  HIS_ID.setField( "HIS_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( HIS_ID );
  makeKeyItem( HIS_ID ); 
  ID.setField( "ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( ID );
  FLOW_ID.setField( "FLOW_ID", DATA_CHAR, 20, 0 );
  makeTableItem( FLOW_ID );
  STAFF.setField( "STAFF", DATA_CHAR, 6, 0 );
  makeTableItem( STAFF );
  FLOW_NAME.setField( "FLOW_NAME", DATA_CHAR, 64, 0 );
  makeTableItem( FLOW_NAME );
  DESCRI.setField( "DESCRI", DATA_CHAR, 128, 0 );
  makeTableItem( DESCRI );
  STATE.setField( "STATE", DATA_CHAR, 6, 0 );
  makeTableItem( STATE );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
  REMARK.setField( "REMARK", DATA_CHAR, 512, 0 );
  makeTableItem( REMARK );
  APP_ID.setField( "APP_ID", DATA_CHAR, 20, 0 );
  makeTableItem( APP_ID );
  APP_STATE.setField( "APP_STATE", DATA_CHAR, 20, 0 );
  makeTableItem( APP_STATE );
  OFFER_NBR.setField( "OFFER_NBR", DATA_CHAR, 128, 0 );
  makeTableItem( OFFER_NBR );
}

CTable_PPM_MDSE_RELA_FLOW_HIS::~CTable_PPM_MDSE_RELA_FLOW_HIS( )
{
    close();
}

